package com.easyclearance.dao;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.easyclearance.entity.OrderInfo;

import io.lettuce.core.dynamic.annotation.Param;

public interface OrderInfoMapper extends BaseMapper<OrderInfo> {

    @Select("SELECT * FROM easyclearance_orderinfo where user_id = #{user_id} AND ec_status = #{ec_status} ORDER BY pubts DESC")
    IPage<OrderInfo> selectPageVo(@Param("page")Page<OrderInfo> page,@Param("orderInfo")OrderInfo orderInfo);
}
